-- @author lixiyong01
-- @date 20240709
-- ods层movielens_links数据处理

use hdp_lbg_supin_zplisting;

insert overwrite table ods_hism_host_zzdetail partition (dt='${RUNDATE}')
select
    items[0] as movie_id,
    items[1] as imdb_id,
    items[2] as tmdb_id
from (
    select split(content,',') as items
    from hdp_lbg_supin_zplisting.raw_hism_host_list
    where dt = '${RUNDATE}'
) t;



